Budget Summary Report
Gray cells are calculated for you and generally should not be altered.
Profit and Loss Summary
Revenue Gross margin Gross margin percentage Sales from new products Regional Sales Breakdown: Northeast region Central region West region Expenses & Margin: SG&A expenses Pretax operating profit (loss) Operating margin
May Actuals $1,200,000 $150,000 12.5% $200,000
May Targets $1,100,000 $160,000 14.5% $150,000
Monthly Variance $100,000 ($10,000) -2.0% $50,000
YTD Actuals $6,200,000 $640,000 10.3% $900,000
YTD Targets $6,000,000 $750,000 12.5% $750,000
YTD Variance
Notes We exceeded our May revenue target by 9%, due to stronger $200,000 execution in the West region.
($110,000) -2.2% $150,000
$400,000 $400,000 $400,000
$400,000 $400,000 $300,000
$0 $0 $100,000
$2,200,000 $2,400,000 $1,600,000
$2,000,000 $2,000,000 $2,000,000
$200,000 $400,000 ($400,000)
$100,000 $50,000 4.2%
$120,000 $40,000 3.6%
$20,000 $10,000 0.5% Monthly Variance ($15,000) ($2,000) ($5,000) ($15,000) $0 ($15,000)
$500,000 $140,000 2.3%
$600,000 $150,000 2.5%
$100,000 ($10,000) -0.2%
Balance Sheet Summary
Period end cash flow Accounts receivable Inventory Total liquid assets Assets required by debt covenants Debt covenant buffer Other Balance Sheet Items: Property, plant, and equipment Accounts payable Long-term liabilities Shareholder equity
May Actuals $35,000 $20,000 $25,000 $75,000 $25,000 $50,000
May Targets $50,000 $22,000 $30,000 $90,000 $25,000 $65,000
YTD Actuals $35,000 $20,000 $25,000 $75,000 $25,000 $50,000
YTD Targets $50,000 $22,000 $30,000 $90,000 $25,000 $65,000
YTD Variance
Notes Cash flow differential was due to cash settlement of legal ($15,000) dispute with Litware, Inc. on May 8. ($2,000) ($5,000) ($15,000) $0 ($15,000) Differential due to purchase of new bursting machine in Plant $2,000 B. $0 $1,000 $2,500
$80,000 $60,000 $30,000 $300,000
$78,000 $60,000 $31,000 $297,500
$2,000 $0 $1,000 $2,500 Monthly Variance (1.30) (20,000) (10) 4
$80,000 $60,000 $30,000 $300,000
$78,000 $60,000 $31,000 $297,500
Operating Metrics Summary
Number of defects per 1,000 widgets produced Production capacity—units per month Days of sales outstanding Number of new orders
May Actuals 2.30 200,000 35 19
May Targets 1.00 220,000 25 15
YTD Actuals 1.46 1,100,000 33 83
YTD Targets 1.00 1,150,000 25 75
YTD Variance 0.46 (50,000) (8) 8
Notes Quality issues were from incorrect paint applied on prod. line 3; manager implemented new detective controls.
Competitive Summary
Contoso, Ltd.
Competitor 1
Competitor 2
Competitor 3
Competitor 4
Other
Notes
Market share Revenue (YTD) New product introductions (YTD) Number of field salespeople (estimated)
20.0% $6,200,000 $900,000 15
25.0% $7,000,000 $500,000 20
15.0% $4,000,000 $0 15
5.0% $1,500,000 $100,000 10
15.0% $4,000,000 $500,000 15
20.0% $6,000,000 $0 N/A
Market share increased due to strength of new product sales.
Profit and Loss Summary Chart
Profit and Loss Summary
$7,000,000 $6,000,000 $5,000,000 $4,000,000
$3,000,000
$2,000,000 $1,000,000 $0 Revenue Gross margin Sales from new SG&A expensesPretax operating products profit (loss)
May Actuals
May Targets
YTD Actuals YTD Targets
Pretax operating profit (loss)
Balance Sheet Summary Chart
Balance Sheet Summary
$90,000 $80,000 $70,000 $60,000
$50,000
$40,000 $30,000 $20,000 $10,000 $0 Period end cash flow Accounts receivable Inventory Property, plant, and equipment Accounts payable Long liabilities
May Actuals
May Targets
Long-term liabilities